package db.tables.polyglott;

import java.sql.SQLException;

import org.hsqldb.Types;

import db.DBObject;
import db.tables.DBCategoryTable;
import db.tables.DBLanguageTable;

public class DBCategoryPGTable extends DBObject {
	public static final String TABLE_NAME = "category_pg";

	public static final String CATEGORY_ID_COL = DBCategoryTable.CATEGORY_ID_COL,
			LANGUAGE_ID_COL = DBLanguageTable.LANGUAGE_ID_COL,
			CATEGORY_NAME_PG_COL = DBCategoryTable.CATEGORY_NAME_COL+"_pg";

	public DBCategoryPGTable() throws ClassNotFoundException, SQLException {
		super(
				TABLE_NAME,
				new Object[][] {
						{ CATEGORY_ID_COL, Types.BIGINT, SQL_NOT_NULL, "" },
						{ LANGUAGE_ID_COL, Types.BIGINT, SQL_NOT_NULL, "" },
						{ CATEGORY_NAME_PG_COL, Types.VARCHAR, SQL_NOT_NULL
							+getSQLForeignKeyReference(DBCategoryTable.TABLE_NAME,CATEGORY_ID_COL)
							+getSQLForeignKeyReference(DBLanguageTable.TABLE_NAME,LANGUAGE_ID_COL)
							, "" } });
	}
	
	
}
